use "dataset_fort_worth_police_violence", clear

drop agency art base

format date %tdnn/dd/YY

tostring hits, format(%20.02f) replace force

tostring date, format("%tdnn/dd/YY") replace force

tostring *, replace

replace race = "Black" if regex(race, "Black")
replace race = "White" if regex(race, "White")
replace race = "Unspecified" if regex(race, "unspecified")
replace race = "Latino" if regex(race, "Latino")

replace name = "Atatiana Jefferson" if regex(name, "Atatiana")
replace name = "De'Morrian Candler-Smith" if name == ///
	"De'Morrian Lemont Candler-Smith"

foreach x of varlist * {
	replace `x' = "\cellcolor{light-gray}\textbf{" + `x' + "}" if ///
		regex(name, "Atatiana Jefferson")
}

#delimit;

listtex 
	using "_output/table A7.tex"
	,
		replace 
		type 
		rstyle(tabular) 	
		head(
			\begin{tabular*}{\hsize}{@{\hskip\tabcolsep
				\extracolsep\fill}l*{6}{l}}
			\toprule Date & Name & Race & Armed & Cause of Death 
				& Coverage \\
			\midrule
		)
		foot("\bottomrule\end{tabular*}")
		;
		
#delimit cr
